Database

Common Functions

Method Name Parameter Return Type Usage Example
setDBDriver dbDriver: String void To set DBDriver DBDriver.setDBDriver(dbDriver);
getConnection void To get connection DBDriver.getConnection();
getResultSet sqlStatement:String ResultSet To get result set DBDriver.getResultSet(sqlStatement)
getNoOfRows long Get the number of rows in the db result set/td> DBDriver.getNoOfRows()
getNoOfColumns int Get the number of columns in the db result set DBDriver.getNoOfColumns()
getColumnNo ComlumnName: String int To get column number DBDriver.getColumnNo(ComlumnName)
getRowNo ComlumnName: String,ColumnVal:String int To get Row number DBDriver.getRowNo(ComlumnName)
getData row: int,column:row String Gets the data from the currently opened sheet based on row and column number DBDriver.getData(row number,column number)